SELECT Id FROM new_searchtable
where ( town like 'Enfield' or town like 'Canaan') and (type = 'R' or type ='O')
and (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Canaan Enfield NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Gentleman's Farm! Circa 1815 Post & Beam Cape, 1990 Addition. Inviting Open Concept Kitchen/Dining/Living Room W/Cathedral Ceiling. Slider to Rear Brick Patio With 66' x 52' Chain Link Fenced Area. Slider to Side Deck W/Cover. Maple Kitchen Cabinets, Stainless Steel Appliances, Breakfast Bar, Center Island, Brick Hearth With Wood Stove. Bedroom/Den/Office With Pellet Stove & Full Bath. Master Bedroom W/3/4 Bath & Walk In Closet. 2 Rooms/Bedroom On 2nd Floor Plus Entrance to 20' x 48' Unfinished Area Over Addition. Stone Foundation W/Bulkhead Under Original Cape. Poured Concrete Foundation W/Crawl Space Under Addition. 24' x 24' Garage. 16' x 25' 3 Bay Garage/Car Port. 8' x 24' Chicken Coop. All Three Outbuildings Have Power. Perennial/Herb Bed With Field Stone Boarder. Garden Area. Lilacs. Forsythia. Stone Walls. Bureau in Master Bedroom Included Along With Appliances Noted. Barking Dog Organic Farm Must Be Seen To Be Appreciated! Don't Miss Out On This One!
Description:APPLEWOOD FARM- Well-maintained, newer construction home in an idyllic setting with stunning westerly views and sunsets. This picturesque property features a substantial apple orchard on the west side of the land and is sited within a neighborhood of lovely homes. It is located just minutes from Goose Pond to the west and Canaan Street Lake to the southeast, home to the prestigious Cardigan Mountain School. The home’s bright interior spaces are thoughtfully designed to capture the surrounding mountain views and natural landscape. The main level offers a spacious open floor plan, where the well-appointed kitchen flows seamlessly into the dining area and large living room, while a recently updated sunroom to the north provides a peaceful place to relax. This level also includes a spacious primary bedroom suite with beautiful finishing touches and a large walk-in closet. On the second floor are two bedrooms–both positioned to take in the views–with generous walk-in closets and a shared centrally located full bathroom. The partially finished walkout lower level is versatile as recreation or entertainment space and includes a den/theater room, private bonus room, and a ¾ bathroom. Outside, the wraparound west-facing deck includes a hot tub from which to enjoy the landscaped grounds and vistas in every season, while a charming detached barn provides parking and additional storage. Nestled in a former apple orchard with over 80 beautiful mature apple trees the property also includes blueberries, raspberries, blackberries, cherries, and Christmas tree plantings. And the large barn combined with over 6 open flat acres in a country setting makes this property ideal as a hobby farm. Conveniently located for an easy commute throughout the Upper Valley including Hanover, Lebanon, Dartmouth College, and Lake Mascoma.
Description:GREEN EAGLE LANDING, Incredible setting right on the water’s edge of Canaan Street Lake, this turnkey Gambrel sits on 2.9 acres with a second abutting 8-acre waterfront parcel. The views are expansive, stretching up the lake toward Cardigan Mountain School, across the reservoir, and toward distant long-range hills and mountains, including Smarts Mountain and Holt’s Ledge at the Dartmouth Skiway. The Timberpeg construction creates a warm, inviting, open-concept interior, featuring a well-appointed kitchen on the main level with plenty of storage in the adjoining pantry entry. The adjacent dining room captures beautiful views over the water and opens to the exterior deck, while the living room—anchored by a central wood stove and a cozy corner perfect for unwinding at the end of the day—connects seamlessly to the dining area to showcase the impressive vistas. Completing the level is a laundry area and 3/4 bathroom. Upstairs, the cathedral ceiling creates a bright, spacious setting for three bedrooms—a generously sized en suite primary and two additional bedrooms that share a central bath. Outside, the large deck is ideal for entertaining, gathering, and enjoying the surrounding landscape, while a nearby screened gazebo provides the perfect spot for dining or playing cards. Just steps away, a dock extends into the water with a landing for boats. There is a large detached shed for additional storage, as well as ample parking. The property is an easy drive to Hanover, Dartmouth College, Dartmouth Health, Lebanon, and surrounding Upper Valley communities.
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm
Description:Super Sunsets on Crystal Lake! This private 2006 lakefront home offers 112' of pristine waterfront with 3 bedrooms, 2 baths, cathedral ceilings, and an open-concept living area filled with natural light and stunning lake views. The finished walkout basement provides extra space for family and guests, while the full-length screened porch, lakeside deck, grassy yard, and established docks make outdoor living easy. A drilled well, storage shed, and shared ownership of 21+ wooded acres with trails across the road complete this exceptional property. Location, location, location!